﻿CREATE TABLE [dbo].[patient_import] (
    [patientID]            INT            IDENTITY (1, 1) NOT NULL,
    [import_source]        SMALLINT       NOT NULL,
    [DLNum]                NVARCHAR (255) NULL,
    [formattedDL]          NVARCHAR (255) NULL,
    [DLState]              NVARCHAR (255) NULL,
    [lname]                NVARCHAR (255) NULL,
    [fname]                NVARCHAR (255) NULL,
    [mname]                NVARCHAR (255) NULL,
    [DOB]                  NVARCHAR (255) NULL,
    [Gender]               NVARCHAR (255) NULL,
    [location]             NVARCHAR (255) NULL,
    [phone]                NVARCHAR (255) NULL,
    [phoneAlt]             NVARCHAR (255) NULL,
    [email]                NVARCHAR (255) NULL,
    [address1]             NVARCHAR (255) NULL,
    [address2]             NVARCHAR (255) NULL,
    [City]                 NVARCHAR (255) NULL,
    [State]                NVARCHAR (255) NULL,
    [Zip]                  NVARCHAR (255) NULL,
    [primaryCaregiver]     NVARCHAR (255) NULL,
    [secondaryCaregiver]   NVARCHAR (MAX) NULL,
    [phD]                  NVARCHAR (255) NULL,
    [primaryCondition]     NVARCHAR (255) NULL,
    [secondaryCondition]   NVARCHAR (255) NULL,
    [numPlants]            NVARCHAR (MAX) NULL,
    [ounce]                NVARCHAR (MAX) NULL,
    [patPatientNotes]      NVARCHAR (255) NULL,
    [enterDate]            NVARCHAR (MAX) NULL,
    [recommendDate]        NVARCHAR (MAX) NULL,
    [dateCaregiverChange]  NVARCHAR (255) NULL,
    [mmrExpDate]           NVARCHAR (MAX) NULL,
    [mmrLicenseNum]        NVARCHAR (255) NULL,
    [callBackDate]         NVARCHAR (255) NULL,
    [callBackTime]         NVARCHAR (255) NULL,
    [proProviderName]      NVARCHAR (255) NULL,
    [proProviderFirstName] NVARCHAR (255) NULL,
    [proProviderLastName]  NVARCHAR (255) NULL,
    [note1]                NVARCHAR (500) NULL,
    [note2]                NVARCHAR (500) NULL,
    [note3]                NVARCHAR (500) NULL,
    [doNotContact]         BIT            NOT NULL
);

